Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 844392 |
| Missing cells | 1809345 |
| Missing cells (%) | 8.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 360.8 MiB |
| Average record size in memory | 448.1 B |
Variable types
| Numeric | 14 |
|---|---|
| DateTime | 1 |
| Categorical | 10 |
Open has constant value "1" | Constant |
Sales is highly overall correlated with Customers | High correlation |
Customers is highly overall correlated with Sales | High correlation |
CompetitionOpenSinceYear is highly overall correlated with CompetitionOpen | High correlation |
Promo2SinceWeek is highly overall correlated with Promo2 and 1 other fields | High correlation |
Promo2SinceYear is highly overall correlated with Promo2Open and 1 other fields | High correlation |
Month is highly overall correlated with WeekOfYear | High correlation |
WeekOfYear is highly overall correlated with Month | High correlation |
CompetitionOpen is highly overall correlated with CompetitionOpenSinceYear | High correlation |
Promo2Open is highly overall correlated with Promo2SinceYear and 1 other fields | High correlation |
StoreType is highly overall correlated with Assortment | High correlation |
Assortment is highly overall correlated with StoreType | High correlation |
Promo2 is highly overall correlated with Promo2SinceWeek and 3 other fields | High correlation |
PromoInterval is highly overall correlated with Promo2SinceWeek and 1 other fields | High correlation |
StateHoliday is highly imbalanced (99.3%) | Imbalance |
CompetitionOpenSinceMonth has 268619 (31.8%) missing values | Missing |
CompetitionOpenSinceYear has 268619 (31.8%) missing values | Missing |
Promo2SinceWeek has 423307 (50.1%) missing values | Missing |
Promo2SinceYear has 423307 (50.1%) missing values | Missing |
PromoInterval has 423307 (50.1%) missing values | Missing |
CompetitionOpen has 343310 (40.7%) zeros | Zeros |
Promo2Open has 481933 (57.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-01-22 12:33:53.267926 |
|---|---|
| Analysis finished | 2024-01-22 12:36:50.546534 |
| Duration | 2 minutes and 57.28 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Store
Real number (ℝ)
| Distinct | 1115 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 558.42292 |
| Minimum | 1 |
|---|---|
| Maximum | 1115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 280 |
| median | 558 |
| Q3 | 837 |
| 95-th percentile | 1060 |
| Maximum | 1115 |
| Range | 1114 |
| Interquartile range (IQR) | 557 |
Descriptive statistics
| Standard deviation | 321.73191 |
|---|---|
| Coefficient of variation (CV) | 0.57614382 |
| Kurtosis | -1.1988414 |
| Mean | 558.42292 |
| Median Absolute Deviation (MAD) | 278 |
| Skewness | 0.00041375446 |
| Sum | 4.7152785 × 108 |
| Variance | 103511.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 562 | 942 | 0.1% |
| 769 | 942 | 0.1% |
| 733 | 942 | 0.1% |
| 423 | 942 | 0.1% |
| 85 | 942 | 0.1% |
| 262 | 942 | 0.1% |
| 335 | 942 | 0.1% |
| 682 | 942 | 0.1% |
| 1097 | 942 | 0.1% |
| 494 | 942 | 0.1% |
| Other values (1105) | 834972 |
| Value | Count | Frequency (%) |
| 1 | 781 | |
| 2 | 784 | |
| 3 | 779 | |
| 4 | 784 | |
| 5 | 779 | |
| 6 | 780 | |
| 7 | 786 | |
| 8 | 784 | |
| 9 | 779 | |
| 10 | 784 |
| Value | Count | Frequency (%) |
| 1115 | 781 | |
| 1114 | 784 | |
| 1113 | 784 | |
| 1112 | 779 | |
| 1111 | 779 | |
| 1110 | 783 | |
| 1109 | 622 | |
| 1108 | 780 | |
| 1107 | 623 | |
| 1106 | 784 |
DayOfWeek
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5203614 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.7236892 |
|---|---|
| Coefficient of variation (CV) | 0.48963417 |
| Kurtosis | -1.2593101 |
| Mean | 3.5203614 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.01929954 |
| Sum | 2972565 |
| Variance | 2.9711045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 144058 | |
| 2 | 143961 | |
| 3 | 141936 | |
| 5 | 138640 | |
| 1 | 137560 | |
| 4 | 134644 | |
| 7 | 3593 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 137560 | |
| 2 | 143961 | |
| 3 | 141936 | |
| 4 | 134644 | |
| 5 | 138640 | |
| 6 | 144058 | |
| 7 | 3593 | 0.4% |
| Value | Count | Frequency (%) |
| 7 | 3593 | 0.4% |
| 6 | 144058 | |
| 5 | 138640 | |
| 4 | 134644 | |
| 3 | 141936 | |
| 2 | 143961 | |
| 1 | 137560 |
Date
Date
| Distinct | 942 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.9 MiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2015-07-31 00:00:00 |
Sales
Real number (ℝ)
| Distinct | 21734 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6955.5143 |
| Minimum | 0 |
|---|---|
| Maximum | 41551 |
| Zeros | 54 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3173 |
| Q1 | 4859 |
| median | 6369 |
| Q3 | 8360 |
| 95-th percentile | 12668 |
| Maximum | 41551 |
| Range | 41551 |
| Interquartile range (IQR) | 3501 |
Descriptive statistics
| Standard deviation | 3104.2147 |
|---|---|
| Coefficient of variation (CV) | 0.44629549 |
| Kurtosis | 4.8520115 |
| Mean | 6955.5143 |
| Median Absolute Deviation (MAD) | 1694 |
| Skewness | 1.593922 |
| Sum | 5.8731806 × 109 |
| Variance | 9636148.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5674 | 215 | < 0.1% |
| 5558 | 197 | < 0.1% |
| 5483 | 196 | < 0.1% |
| 6049 | 195 | < 0.1% |
| 6214 | 195 | < 0.1% |
| 5723 | 194 | < 0.1% |
| 5449 | 192 | < 0.1% |
| 5489 | 191 | < 0.1% |
| 5140 | 191 | < 0.1% |
| 5041 | 190 | < 0.1% |
| Other values (21724) | 842436 |
| Value | Count | Frequency (%) |
| 0 | 54 | |
| 46 | 1 | < 0.1% |
| 124 | 1 | < 0.1% |
| 133 | 1 | < 0.1% |
| 286 | 1 | < 0.1% |
| 297 | 1 | < 0.1% |
| 316 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 506 | 1 | < 0.1% |
| 520 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41551 | 1 | |
| 38722 | 1 | |
| 38484 | 1 | |
| 38367 | 1 | |
| 38037 | 1 | |
| 38025 | 1 | |
| 37646 | 1 | |
| 37403 | 1 | |
| 37376 | 1 | |
| 37122 | 1 |
Customers
Real number (ℝ)
| Distinct | 4086 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 762.7284 |
| Minimum | 0 |
|---|---|
| Maximum | 7388 |
| Zeros | 52 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 349 |
| Q1 | 519 |
| median | 676 |
| Q3 | 893 |
| 95-th percentile | 1440 |
| Maximum | 7388 |
| Range | 7388 |
| Interquartile range (IQR) | 374 |
Descriptive statistics
| Standard deviation | 401.22767 |
|---|---|
| Coefficient of variation (CV) | 0.52604266 |
| Kurtosis | 13.313755 |
| Mean | 762.7284 |
| Median Absolute Deviation (MAD) | 179 |
| Skewness | 2.7881104 |
| Sum | 6.4404176 × 108 |
| Variance | 160983.65 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 560 | 2414 | 0.3% |
| 576 | 2363 | 0.3% |
| 603 | 2337 | 0.3% |
| 571 | 2330 | 0.3% |
| 555 | 2328 | 0.3% |
| 566 | 2327 | 0.3% |
| 517 | 2326 | 0.3% |
| 539 | 2309 | 0.3% |
| 651 | 2299 | 0.3% |
| 533 | 2298 | 0.3% |
| Other values (4076) | 821061 |
| Value | Count | Frequency (%) |
| 0 | 52 | |
| 3 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 36 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7388 | 1 | |
| 5494 | 1 | |
| 5458 | 1 | |
| 5387 | 1 | |
| 5297 | 1 | |
| 5192 | 1 | |
| 5152 | 1 | |
| 5145 | 1 | |
| 5132 | 1 | |
| 5112 | 1 |
Open
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 844392 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 844392 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 844392 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 844392 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 844392 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 844392 |
Promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
StateHoliday
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.4 MiB |
| NotHoliday | |
|---|---|
| a | 694 |
| b | 145 |
| c | 71 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.9903007 |
| Min length | 1 |
Characters and Unicode
| Total characters | 8435730 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NotHoliday |
|---|---|
| 2nd row | NotHoliday |
| 3rd row | NotHoliday |
| 4th row | NotHoliday |
| 5th row | NotHoliday |
Common Values
| Value | Count | Frequency (%) |
| NotHoliday | 843482 | |
| a | 694 | 0.1% |
| b | 145 | < 0.1% |
| c | 71 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| notholiday | 843482 | |
| a | 694 | 0.1% |
| b | 145 | < 0.1% |
| c | 71 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1686964 | |
| a | 844176 | |
| N | 843482 | |
| t | 843482 | |
| H | 843482 | |
| l | 843482 | |
| i | 843482 | |
| d | 843482 | |
| y | 843482 | |
| b | 145 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6748766 | |
| Uppercase Letter | 1686964 | 20.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 1686964 | |
| a | 844176 | |
| t | 843482 | |
| l | 843482 | |
| i | 843482 | |
| d | 843482 | |
| y | 843482 | |
| b | 145 | < 0.1% |
| c | 71 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 843482 | |
| H | 843482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8435730 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 1686964 | |
| a | 844176 | |
| N | 843482 | |
| t | 843482 | |
| H | 843482 | |
| l | 843482 | |
| i | 843482 | |
| d | 843482 | |
| y | 843482 | |
| b | 145 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8435730 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 1686964 | |
| a | 844176 | |
| N | 843482 | |
| t | 843482 | |
| H | 843482 | |
| l | 843482 | |
| i | 843482 | |
| d | 843482 | |
| y | 843482 | |
| b | 145 | < 0.1% |
SchoolHoliday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
StoreType
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| a | |
|---|---|
| d | |
| c | |
| b | 15563 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | c |
|---|---|
| 2nd row | a |
| 3rd row | a |
| 4th row | c |
| 5th row | a |
Common Values
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 844392 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 844392 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 457077 | |
| d | 258774 | |
| c | 112978 | 13.4% |
| b | 15563 | 1.8% |
Assortment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| a | |
|---|---|
| c | |
| b | 8212 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | a |
|---|---|
| 2nd row | a |
| 3rd row | a |
| 4th row | c |
| 5th row | a |
Common Values
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 844392 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 844392 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 444909 | |
| c | 391271 | |
| b | 8212 | 1.0% |
CompetitionDistance
Real number (ℝ)
| Distinct | 654 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2186 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5457.9796 |
| Minimum | 20 |
|---|---|
| Maximum | 75860 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 130 |
| Q1 | 710 |
| median | 2320 |
| Q3 | 6890 |
| 95-th percentile | 20390 |
| Maximum | 75860 |
| Range | 75840 |
| Interquartile range (IQR) | 6180 |
Descriptive statistics
| Standard deviation | 7809.4373 |
|---|---|
| Coefficient of variation (CV) | 1.4308293 |
| Kurtosis | 13.413381 |
| Mean | 5457.9796 |
| Median Absolute Deviation (MAD) | 1970 |
| Skewness | 2.9751106 |
| Sum | 4.5967432 × 109 |
| Variance | 60987311 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 250 | 9210 | 1.1% |
| 50 | 6249 | 0.7% |
| 350 | 6239 | 0.7% |
| 1200 | 6072 | 0.7% |
| 190 | 6066 | 0.7% |
| 90 | 5609 | 0.7% |
| 180 | 5422 | 0.6% |
| 150 | 5294 | 0.6% |
| 330 | 5294 | 0.6% |
| 140 | 4684 | 0.6% |
| Other values (644) | 782067 |
| Value | Count | Frequency (%) |
| 20 | 779 | 0.1% |
| 30 | 3116 | |
| 40 | 3890 | |
| 50 | 6249 | |
| 60 | 2342 | 0.3% |
| 70 | 3736 | |
| 80 | 2331 | 0.3% |
| 90 | 5609 | |
| 100 | 3900 | |
| 110 | 4516 |
| Value | Count | Frequency (%) |
| 75860 | 887 | |
| 58260 | 885 | |
| 48330 | 784 | |
| 46590 | 784 | |
| 45740 | 780 | |
| 44320 | 780 | |
| 40860 | 881 | |
| 40540 | 780 | |
| 38710 | 784 | |
| 38630 | 882 |
CompetitionOpenSinceMonth
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 268619 |
| Missing (%) | 31.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.2248786 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2101438 |
|---|---|
| Coefficient of variation (CV) | 0.44431803 |
| Kurtosis | -1.247663 |
| Mean | 7.2248786 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.17157646 |
| Sum | 4159890 |
| Variance | 10.305023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 95467 | 11.3% |
| 4 | 72256 | 8.6% |
| 11 | 70032 | 8.3% |
| 3 | 52685 | 6.2% |
| 7 | 49009 | 5.8% |
| 12 | 47887 | 5.7% |
| 10 | 46198 | 5.5% |
| 6 | 37759 | 4.5% |
| 5 | 32862 | 3.9% |
| 2 | 31360 | 3.7% |
| Other values (2) | 40258 | 4.8% |
| (Missing) | 268619 |
| Value | Count | Frequency (%) |
| 1 | 10297 | 1.2% |
| 2 | 31360 | 3.7% |
| 3 | 52685 | |
| 4 | 72256 | |
| 5 | 32862 | 3.9% |
| 6 | 37759 | 4.5% |
| 7 | 49009 | |
| 8 | 29961 | 3.5% |
| 9 | 95467 | |
| 10 | 46198 |
| Value | Count | Frequency (%) |
| 12 | 47887 | |
| 11 | 70032 | |
| 10 | 46198 | |
| 9 | 95467 | |
| 8 | 29961 | 3.5% |
| 7 | 49009 | |
| 6 | 37759 | 4.5% |
| 5 | 32862 | 3.9% |
| 4 | 72256 | |
| 3 | 52685 |
CompetitionOpenSinceYear
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 268619 |
| Missing (%) | 31.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2008.6977 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 2001 |
| Q1 | 2006 |
| median | 2010 |
| Q3 | 2013 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.9780481 |
|---|---|
| Coefficient of variation (CV) | 0.0029760815 |
| Kurtosis | 121.84638 |
| Mean | 2008.6977 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -7.5221054 |
| Sum | 1.1565539 × 109 |
| Variance | 35.73706 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 63108 | 7.5% |
| 2012 | 61719 | 7.3% |
| 2014 | 52815 | 6.3% |
| 2005 | 46705 | 5.5% |
| 2010 | 42716 | 5.1% |
| 2011 | 41366 | 4.9% |
| 2009 | 40713 | 4.8% |
| 2008 | 40198 | 4.8% |
| 2007 | 36131 | 4.3% |
| 2006 | 35543 | 4.2% |
| Other values (13) | 114759 | |
| (Missing) | 268619 |
| Value | Count | Frequency (%) |
| 1900 | 622 | 0.1% |
| 1961 | 779 | 0.1% |
| 1990 | 3887 | 0.5% |
| 1994 | 1552 | 0.2% |
| 1995 | 1404 | 0.2% |
| 1998 | 766 | 0.1% |
| 1999 | 6213 | 0.7% |
| 2000 | 7631 | 0.9% |
| 2001 | 12157 | |
| 2002 | 20736 |
| Value | Count | Frequency (%) |
| 2015 | 28844 | |
| 2014 | 52815 | |
| 2013 | 63108 | |
| 2012 | 61719 | |
| 2011 | 41366 | |
| 2010 | 42716 | |
| 2009 | 40713 | |
| 2008 | 40198 | |
| 2007 | 36131 | |
| 2006 | 35543 |
Promo2
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Promo2SinceWeek
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 423307 |
| Missing (%) | 50.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.253426 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 13 |
| median | 22 |
| Q3 | 37 |
| 95-th percentile | 45 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 14.100569 |
|---|---|
| Coefficient of variation (CV) | 0.60638671 |
| Kurtosis | -1.3690876 |
| Mean | 23.253426 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.10641224 |
| Sum | 9791669 |
| Variance | 198.82603 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 60541 | 7.2% |
| 40 | 51507 | 6.1% |
| 31 | 33238 | 3.9% |
| 10 | 32214 | 3.8% |
| 5 | 29722 | 3.5% |
| 37 | 27116 | 3.2% |
| 1 | 26873 | 3.2% |
| 13 | 24579 | 2.9% |
| 45 | 24072 | 2.9% |
| 22 | 23645 | 2.8% |
| Other values (14) | 87578 | 10.4% |
| (Missing) | 423307 |
| Value | Count | Frequency (%) |
| 1 | 26873 | |
| 5 | 29722 | |
| 6 | 771 | 0.1% |
| 9 | 10293 | 1.2% |
| 10 | 32214 | |
| 13 | 24579 | |
| 14 | 60541 | |
| 18 | 22456 | 2.7% |
| 22 | 23645 | 2.8% |
| 23 | 3558 | 0.4% |
| Value | Count | Frequency (%) |
| 50 | 780 | 0.1% |
| 49 | 622 | 0.1% |
| 48 | 7033 | 0.8% |
| 45 | 24072 | |
| 44 | 2182 | 0.3% |
| 40 | 51507 | |
| 39 | 3889 | 0.5% |
| 37 | 27116 | |
| 36 | 7620 | 0.9% |
| 35 | 18888 | 2.2% |
Promo2SinceYear
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 423307 |
| Missing (%) | 50.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2011.754 |
| Minimum | 2009 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2011 |
| median | 2012 |
| Q3 | 2013 |
| 95-th percentile | 2014 |
| Maximum | 2015 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6609621 |
|---|---|
| Coefficient of variation (CV) | 0.00082562883 |
| Kurtosis | -1.03757 |
| Mean | 2011.754 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.12274344 |
| Sum | 8.4711944 × 108 |
| Variance | 2.7587952 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2011 | 95040 | 11.3% |
| 2013 | 91866 | 10.9% |
| 2014 | 65768 | 7.8% |
| 2012 | 60716 | 7.2% |
| 2009 | 53826 | 6.4% |
| 2010 | 46414 | 5.5% |
| 2015 | 7455 | 0.9% |
| (Missing) | 423307 |
| Value | Count | Frequency (%) |
| 2009 | 53826 | |
| 2010 | 46414 | |
| 2011 | 95040 | |
| 2012 | 60716 | |
| 2013 | 91866 | |
| 2014 | 65768 | |
| 2015 | 7455 | 0.9% |
| Value | Count | Frequency (%) |
| 2015 | 7455 | 0.9% |
| 2014 | 65768 | |
| 2013 | 91866 | |
| 2012 | 60716 | |
| 2011 | 95040 | |
| 2010 | 46414 | |
| 2009 | 53826 |
PromoInterval
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 423307 |
| Missing (%) | 50.1% |
| Memory size | 48.4 MiB |
| Jan,Apr,Jul,Oct | |
|---|---|
| Feb,May,Aug,Nov | |
| Mar,Jun,Sept,Dec |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 15.191574 |
| Min length | 15 |
Characters and Unicode
| Total characters | 6396944 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jan,Apr,Jul,Oct |
|---|---|
| 2nd row | Jan,Apr,Jul,Oct |
| 3rd row | Jan,Apr,Jul,Oct |
| 4th row | Jan,Apr,Jul,Oct |
| 5th row | Feb,May,Aug,Nov |
Common Values
| Value | Count | Frequency (%) |
| Jan,Apr,Jul,Oct | 242411 | |
| Feb,May,Aug,Nov | 98005 | 11.6% |
| Mar,Jun,Sept,Dec | 80669 | 9.6% |
| (Missing) | 423307 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| jan,apr,jul,oct | 242411 | |
| feb,may,aug,nov | 98005 | |
| mar,jun,sept,dec | 80669 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 1263255 | |
| J | 565491 | 8.8% |
| u | 421085 | 6.6% |
| a | 421085 | 6.6% |
| A | 340416 | 5.3% |
| c | 323080 | 5.1% |
| t | 323080 | 5.1% |
| r | 323080 | 5.1% |
| p | 323080 | 5.1% |
| n | 323080 | 5.1% |
| Other values (13) | 1770212 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3449349 | |
| Uppercase Letter | 1684340 | |
| Other Punctuation | 1263255 | 19.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 421085 | |
| a | 421085 | |
| c | 323080 | |
| t | 323080 | |
| r | 323080 | |
| p | 323080 | |
| n | 323080 | |
| e | 259343 | |
| l | 242411 | |
| b | 98005 | 2.8% |
| Other values (4) | 392020 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 565491 | |
| A | 340416 | |
| O | 242411 | |
| M | 178674 | 10.6% |
| F | 98005 | 5.8% |
| N | 98005 | 5.8% |
| S | 80669 | 4.8% |
| D | 80669 | 4.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1263255 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5133689 | |
| Common | 1263255 | 19.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| J | 565491 | 11.0% |
| u | 421085 | 8.2% |
| a | 421085 | 8.2% |
| A | 340416 | 6.6% |
| c | 323080 | 6.3% |
| t | 323080 | 6.3% |
| r | 323080 | 6.3% |
| p | 323080 | 6.3% |
| n | 323080 | 6.3% |
| e | 259343 | 5.1% |
| Other values (12) | 1510869 |
Common
| Value | Count | Frequency (%) |
| , | 1263255 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6396944 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| , | 1263255 | |
| J | 565491 | 8.8% |
| u | 421085 | 6.6% |
| a | 421085 | 6.6% |
| A | 340416 | 5.3% |
| c | 323080 | 5.1% |
| t | 323080 | 5.1% |
| r | 323080 | 5.1% |
| p | 323080 | 5.1% |
| n | 323080 | 5.1% |
| Other values (13) | 1770212 |
Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.6 MiB |
| 2013 | |
|---|---|
| 2014 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3377568 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2013 | 337943 | |
| 2014 | 310417 | |
| 2015 | 196032 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2013 | 337943 | |
| 2014 | 310417 | |
| 2015 | 196032 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3377568 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3377568 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3377568 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.8457375 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.3239313 |
|---|---|
| Coefficient of variation (CV) | 0.56860768 |
| Kurtosis | -1.0331705 |
| Mean | 5.8457375 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.2577004 |
| Sum | 4936094 |
| Variance | 11.048519 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 86343 | |
| 3 | 85980 | |
| 7 | 85587 | |
| 6 | 82576 | |
| 4 | 81731 | |
| 2 | 80243 | |
| 5 | 80103 | |
| 8 | 54413 | |
| 10 | 53292 | |
| 9 | 52330 | |
| Other values (2) | 101794 |
| Value | Count | Frequency (%) |
| 1 | 86343 | |
| 2 | 80243 | |
| 3 | 85980 | |
| 4 | 81731 | |
| 5 | 80103 | |
| 6 | 82576 | |
| 7 | 85587 | |
| 8 | 54413 | |
| 9 | 52330 | |
| 10 | 53292 |
| Value | Count | Frequency (%) |
| 12 | 50393 | |
| 11 | 51401 | |
| 10 | 53292 | |
| 9 | 52330 | |
| 8 | 54413 | |
| 7 | 85587 | |
| 6 | 82576 | |
| 5 | 80103 | |
| 4 | 81731 | |
| 3 | 85980 |
Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.835683 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.683456 |
|---|---|
| Coefficient of variation (CV) | 0.54834743 |
| Kurtosis | -1.1796906 |
| Mean | 15.835683 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.011117124 |
| Sum | 13371524 |
| Variance | 75.402409 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 30121 | 3.6% |
| 4 | 29474 | 3.5% |
| 27 | 29270 | 3.5% |
| 13 | 29262 | 3.5% |
| 23 | 29241 | 3.5% |
| 2 | 29235 | 3.5% |
| 16 | 29203 | 3.5% |
| 18 | 29060 | 3.4% |
| 28 | 28367 | 3.4% |
| 7 | 28359 | 3.4% |
| Other values (21) | 552800 |
| Value | Count | Frequency (%) |
| 1 | 19368 | |
| 2 | 29235 | |
| 3 | 25058 | |
| 4 | 29474 | |
| 5 | 28176 | |
| 6 | 27566 | |
| 7 | 28359 | |
| 8 | 27961 | |
| 9 | 27068 | |
| 10 | 28159 |
| Value | Count | Frequency (%) |
| 31 | 15924 | |
| 30 | 26326 | |
| 29 | 23575 | |
| 28 | 28367 | |
| 27 | 29270 | |
| 26 | 26168 | |
| 25 | 27065 | |
| 24 | 28163 | |
| 23 | 29241 | |
| 22 | 27988 |
WeekOfYear
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.646801 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 23 |
| Q3 | 35 |
| 95-th percentile | 49 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 14.389785 |
|---|---|
| Coefficient of variation (CV) | 0.60852987 |
| Kurtosis | -1.0257391 |
| Mean | 23.646801 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.26228278 |
| Sum | 19967170 |
| Variance | 207.06591 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 26 | 20121 | 2.4% |
| 12 | 20099 | 2.4% |
| 9 | 20093 | 2.4% |
| 11 | 20081 | 2.4% |
| 6 | 20068 | 2.4% |
| 5 | 20065 | 2.4% |
| 8 | 20053 | 2.4% |
| 10 | 20051 | 2.4% |
| 4 | 20047 | 2.4% |
| 3 | 20043 | 2.4% |
| Other values (42) | 643671 |
| Value | Count | Frequency (%) |
| 1 | 15161 | |
| 2 | 19448 | |
| 3 | 20043 | |
| 4 | 20047 | |
| 5 | 20065 | |
| 6 | 20068 | |
| 7 | 20041 | |
| 8 | 20053 | |
| 9 | 20093 | |
| 10 | 20051 |
| Value | Count | Frequency (%) |
| 52 | 8319 | |
| 51 | 12355 | |
| 50 | 12333 | |
| 49 | 12334 | |
| 48 | 12334 | |
| 47 | 12182 | |
| 46 | 12333 | |
| 45 | 12334 | |
| 44 | 11042 | |
| 43 | 12361 |
CompetitionOpen
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 336 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.953548 |
| Minimum | 0 |
|---|---|
| Maximum | 1386 |
| Zeros | 343310 |
| Zeros (%) | 40.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 16 |
| Q3 | 73 |
| 95-th percentile | 143 |
| Maximum | 1386 |
| Range | 1386 |
| Interquartile range (IQR) | 73 |
Descriptive statistics
| Standard deviation | 65.189741 |
|---|---|
| Coefficient of variation (CV) | 1.5538553 |
| Kurtosis | 131.80386 |
| Mean | 41.953548 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 7.548298 |
| Sum | 35425240 |
| Variance | 4249.7024 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 343310 | |
| 7 | 5369 | 0.6% |
| 4 | 5361 | 0.6% |
| 6 | 5323 | 0.6% |
| 10 | 5255 | 0.6% |
| 8 | 5247 | 0.6% |
| 5 | 5211 | 0.6% |
| 9 | 5201 | 0.6% |
| 11 | 5119 | 0.6% |
| 12 | 5004 | 0.6% |
| Other values (326) | 453992 |
| Value | Count | Frequency (%) |
| 0 | 343310 | |
| 1 | 4482 | 0.5% |
| 2 | 4779 | 0.6% |
| 3 | 4680 | 0.6% |
| 4 | 5361 | 0.6% |
| 5 | 5211 | 0.6% |
| 6 | 5323 | 0.6% |
| 7 | 5369 | 0.6% |
| 8 | 5247 | 0.6% |
| 9 | 5201 | 0.6% |
| Value | Count | Frequency (%) |
| 1386 | 27 | |
| 1385 | 25 | |
| 1384 | 23 | |
| 1383 | 24 | |
| 1382 | 26 | |
| 1381 | 24 | |
| 1380 | 25 | |
| 1373 | 23 | |
| 1372 | 25 | |
| 1371 | 24 |
Promo2Open
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 566 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.04371 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 481933 |
| Zeros (%) | 57.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 24.918033 |
| 95-th percentile | 52.819672 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 24.918033 |
Descriptive statistics
| Standard deviation | 18.987353 |
|---|---|
| Coefficient of variation (CV) | 1.4556712 |
| Kurtosis | 0.2345155 |
| Mean | 13.04371 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.2349221 |
| Sum | 11014004 |
| Variance | 360.51958 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 481933 | |
| 23.54098361 | 1681 | 0.2% |
| 23.31147541 | 1652 | 0.2% |
| 24 | 1619 | 0.2% |
| 23.7704918 | 1608 | 0.2% |
| 24.2295082 | 1599 | 0.2% |
| 24.45901639 | 1598 | 0.2% |
| 24.68852459 | 1589 | 0.2% |
| 22.39344262 | 1521 | 0.2% |
| 25.37704918 | 1504 | 0.2% |
| Other values (556) | 348088 |
| Value | Count | Frequency (%) |
| 0 | 481933 | |
| 0.2295081967 | 1055 | 0.1% |
| 0.4590163934 | 1048 | 0.1% |
| 0.6885245902 | 1045 | 0.1% |
| 0.9180327869 | 1019 | 0.1% |
| 0.9836065574 | 2 | < 0.1% |
| 1.147540984 | 1057 | 0.1% |
| 1.213114754 | 31 | < 0.1% |
| 1.37704918 | 1020 | 0.1% |
| 1.442622951 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 35 | < 0.1% |
| 71.7704918 | 42 | < 0.1% |
| 71.54098361 | 42 | < 0.1% |
| 71.31147541 | 42 | < 0.1% |
| 71.08196721 | 42 | < 0.1% |
| 70.85245902 | 42 | < 0.1% |
| 70.62295082 | 217 | |
| 70.39344262 | 252 | |
| 70.16393443 | 251 | |
| 69.93442623 | 251 |
IsPromo2Month
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 718660 | |
| 1 | 125732 | 14.9% |
| Store | DayOfWeek | Sales | Customers | CompetitionDistance | CompetitionOpenSinceMonth | CompetitionOpenSinceYear | Promo2SinceWeek | Promo2SinceYear | Month | Day | WeekOfYear | CompetitionOpen | Promo2Open | Promo | StateHoliday | SchoolHoliday | StoreType | Assortment | Promo2 | PromoInterval | Year | IsPromo2Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Store | 1.000 | 0.000 | 0.001 | 0.031 | -0.046 | -0.052 | 0.003 | 0.007 | 0.034 | 0.001 | -0.000 | 0.001 | -0.005 | -0.007 | 0.000 | 0.007 | 0.000 | 0.098 | 0.115 | 0.072 | 0.160 | 0.005 | 0.041 |
| DayOfWeek | 0.000 | 1.000 | -0.179 | -0.146 | -0.000 | 0.000 | 0.001 | -0.001 | 0.003 | -0.019 | 0.008 | -0.015 | -0.002 | -0.004 | 0.414 | 0.026 | 0.204 | 0.168 | 0.149 | 0.029 | 0.007 | 0.007 | 0.016 |
| Sales | 0.001 | -0.179 | 1.000 | 0.832 | -0.035 | -0.042 | 0.055 | 0.097 | -0.034 | 0.062 | -0.065 | 0.062 | -0.024 | -0.081 | 0.370 | 0.055 | 0.038 | 0.112 | 0.094 | 0.119 | 0.051 | 0.035 | 0.062 |
| Customers | 0.031 | -0.146 | 0.832 | 1.000 | -0.257 | -0.032 | 0.054 | 0.038 | 0.045 | 0.054 | -0.047 | 0.055 | -0.015 | -0.205 | 0.208 | 0.067 | 0.023 | 0.328 | 0.272 | 0.207 | 0.048 | 0.019 | 0.101 |
| CompetitionDistance | -0.046 | -0.000 | -0.035 | -0.257 | 1.000 | -0.034 | -0.002 | -0.020 | -0.089 | -0.000 | -0.000 | -0.000 | -0.005 | -0.047 | 0.004 | 0.013 | 0.004 | 0.162 | 0.124 | 0.160 | 0.068 | 0.003 | 0.067 |
| CompetitionOpenSinceMonth | -0.052 | 0.000 | -0.042 | -0.032 | -0.034 | 1.000 | -0.124 | -0.039 | 0.045 | -0.001 | 0.000 | -0.001 | 0.057 | -0.018 | 0.000 | 0.010 | 0.000 | 0.120 | 0.105 | 0.156 | 0.192 | 0.010 | 0.053 |
| CompetitionOpenSinceYear | 0.003 | 0.001 | 0.055 | 0.054 | -0.002 | -0.124 | 1.000 | -0.001 | 0.102 | 0.001 | -0.000 | 0.001 | -0.978 | -0.085 | 0.000 | 0.003 | 0.001 | 0.065 | 0.112 | 0.084 | 0.130 | 0.006 | 0.043 |
| Promo2SinceWeek | 0.007 | -0.001 | 0.097 | 0.038 | -0.020 | -0.039 | -0.001 | 1.000 | -0.216 | -0.028 | 0.001 | -0.026 | -0.076 | 0.079 | 0.000 | 0.014 | 0.004 | 0.154 | 0.210 | 1.000 | 0.596 | 0.029 | 0.076 |
| Promo2SinceYear | 0.034 | 0.003 | -0.034 | 0.045 | -0.089 | 0.045 | 0.102 | -0.216 | 1.000 | -0.008 | 0.001 | -0.007 | 0.010 | -0.898 | 0.000 | 0.012 | 0.006 | 0.127 | 0.193 | 1.000 | 0.301 | 0.029 | 0.168 |
| Month | 0.001 | -0.019 | 0.062 | 0.054 | -0.000 | -0.001 | 0.001 | -0.028 | -0.008 | 1.000 | -0.006 | 0.963 | 0.010 | -0.002 | 0.041 | 0.035 | 0.411 | 0.007 | 0.006 | 0.029 | 0.020 | 0.263 | 0.187 |
| Day | -0.000 | 0.008 | -0.065 | -0.047 | -0.000 | 0.000 | -0.000 | 0.001 | 0.001 | -0.006 | 1.000 | 0.047 | 0.001 | 0.005 | 0.315 | 0.022 | 0.140 | 0.000 | 0.000 | 0.000 | 0.000 | 0.016 | 0.026 |
| WeekOfYear | 0.001 | -0.015 | 0.062 | 0.055 | -0.000 | -0.001 | 0.001 | -0.026 | -0.007 | 0.963 | 0.047 | 1.000 | 0.010 | 0.004 | 0.118 | 0.034 | 0.385 | 0.007 | 0.006 | 0.028 | 0.019 | 0.255 | 0.145 |
| CompetitionOpen | -0.005 | -0.002 | -0.024 | -0.015 | -0.005 | 0.057 | -0.978 | -0.076 | 0.010 | 0.010 | 0.001 | 0.010 | 1.000 | -0.018 | 0.000 | 0.002 | 0.002 | 0.050 | 0.078 | 0.061 | 0.089 | 0.046 | 0.034 |
| Promo2Open | -0.007 | -0.004 | -0.081 | -0.205 | -0.047 | -0.018 | -0.085 | 0.079 | -0.898 | -0.002 | 0.005 | 0.004 | -0.018 | 1.000 | 0.012 | 0.006 | 0.023 | 0.077 | 0.086 | 0.790 | 0.133 | 0.214 | 0.433 |
| Promo | 0.000 | 0.414 | 0.370 | 0.208 | 0.004 | 0.000 | 0.000 | 0.000 | 0.000 | 0.041 | 0.315 | 0.118 | 0.000 | 0.012 | 1.000 | 0.011 | 0.029 | 0.018 | 0.013 | 0.000 | 0.000 | 0.024 | 0.005 |
| StateHoliday | 0.007 | 0.026 | 0.055 | 0.067 | 0.013 | 0.010 | 0.003 | 0.014 | 0.012 | 0.035 | 0.022 | 0.034 | 0.002 | 0.006 | 0.011 | 1.000 | 0.032 | 0.071 | 0.068 | 0.010 | 0.004 | 0.004 | 0.006 |
| SchoolHoliday | 0.000 | 0.204 | 0.038 | 0.023 | 0.004 | 0.000 | 0.001 | 0.004 | 0.006 | 0.411 | 0.140 | 0.385 | 0.002 | 0.023 | 0.029 | 0.032 | 1.000 | 0.005 | 0.004 | 0.008 | 0.000 | 0.045 | 0.018 |
| StoreType | 0.098 | 0.168 | 0.112 | 0.328 | 0.162 | 0.120 | 0.065 | 0.154 | 0.127 | 0.007 | 0.000 | 0.007 | 0.050 | 0.077 | 0.018 | 0.071 | 0.005 | 1.000 | 0.538 | 0.108 | 0.072 | 0.010 | 0.055 |
| Assortment | 0.115 | 0.149 | 0.094 | 0.272 | 0.124 | 0.105 | 0.112 | 0.210 | 0.193 | 0.006 | 0.000 | 0.006 | 0.078 | 0.086 | 0.013 | 0.068 | 0.004 | 0.538 | 1.000 | 0.016 | 0.086 | 0.007 | 0.016 |
| Promo2 | 0.072 | 0.029 | 0.119 | 0.207 | 0.160 | 0.156 | 0.084 | 1.000 | 1.000 | 0.029 | 0.000 | 0.028 | 0.061 | 0.790 | 0.000 | 0.010 | 0.008 | 0.108 | 0.016 | 1.000 | 1.000 | 0.031 | 0.419 |
| PromoInterval | 0.160 | 0.007 | 0.051 | 0.048 | 0.068 | 0.192 | 0.130 | 0.596 | 0.301 | 0.020 | 0.000 | 0.019 | 0.089 | 0.133 | 0.000 | 0.004 | 0.000 | 0.072 | 0.086 | 1.000 | 1.000 | 0.022 | 0.033 |
| Year | 0.005 | 0.007 | 0.035 | 0.019 | 0.003 | 0.010 | 0.006 | 0.029 | 0.029 | 0.263 | 0.016 | 0.255 | 0.046 | 0.214 | 0.024 | 0.004 | 0.045 | 0.010 | 0.007 | 0.031 | 0.022 | 1.000 | 0.065 |
| IsPromo2Month | 0.041 | 0.016 | 0.062 | 0.101 | 0.067 | 0.053 | 0.043 | 0.076 | 0.168 | 0.187 | 0.026 | 0.145 | 0.034 | 0.433 | 0.005 | 0.006 | 0.018 | 0.055 | 0.016 | 0.419 | 0.033 | 0.065 | 1.000 |
| Store | DayOfWeek | Date | Sales | Customers | Open | Promo | StateHoliday | SchoolHoliday | StoreType | Assortment | CompetitionDistance | CompetitionOpenSinceMonth | CompetitionOpenSinceYear | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | Year | Month | Day | WeekOfYear | CompetitionOpen | Promo2Open | IsPromo2Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 5 | 2015-07-31 | 5263 | 555 | 1 | 1 | NotHoliday | 1 | c | a | 1270.0 | 9.0 | 2008.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 82.0 | 0.000000 | 0 |
| 1 | 2 | 5 | 2015-07-31 | 6064 | 625 | 1 | 1 | NotHoliday | 1 | a | a | 570.0 | 11.0 | 2007.0 | 1 | 13.0 | 2010.0 | Jan,Apr,Jul,Oct | 2015 | 7 | 31 | 31 | 92.0 | 64.131148 | 1 |
| 2 | 3 | 5 | 2015-07-31 | 8314 | 821 | 1 | 1 | NotHoliday | 1 | a | a | 14130.0 | 12.0 | 2006.0 | 1 | 14.0 | 2011.0 | Jan,Apr,Jul,Oct | 2015 | 7 | 31 | 31 | 103.0 | 51.901639 | 1 |
| 3 | 4 | 5 | 2015-07-31 | 13995 | 1498 | 1 | 1 | NotHoliday | 1 | c | c | 620.0 | 9.0 | 2009.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 70.0 | 0.000000 | 0 |
| 4 | 5 | 5 | 2015-07-31 | 4822 | 559 | 1 | 1 | NotHoliday | 1 | a | a | 29910.0 | 4.0 | 2015.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 3.0 | 0.000000 | 0 |
| 5 | 6 | 5 | 2015-07-31 | 5651 | 589 | 1 | 1 | NotHoliday | 1 | a | a | 310.0 | 12.0 | 2013.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 19.0 | 0.000000 | 0 |
| 6 | 7 | 5 | 2015-07-31 | 15344 | 1414 | 1 | 1 | NotHoliday | 1 | a | c | 24000.0 | 4.0 | 2013.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 27.0 | 0.000000 | 0 |
| 7 | 8 | 5 | 2015-07-31 | 8492 | 833 | 1 | 1 | NotHoliday | 1 | a | a | 7520.0 | 10.0 | 2014.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 9.0 | 0.000000 | 0 |
| 8 | 9 | 5 | 2015-07-31 | 8565 | 687 | 1 | 1 | NotHoliday | 1 | a | c | 2030.0 | 8.0 | 2000.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 179.0 | 0.000000 | 0 |
| 9 | 10 | 5 | 2015-07-31 | 7185 | 681 | 1 | 1 | NotHoliday | 1 | a | a | 3160.0 | 9.0 | 2009.0 | 0 | NaN | NaN | NaN | 2015 | 7 | 31 | 31 | 70.0 | 0.000000 | 0 |
| Store | DayOfWeek | Date | Sales | Customers | Open | Promo | StateHoliday | SchoolHoliday | StoreType | Assortment | CompetitionDistance | CompetitionOpenSinceMonth | CompetitionOpenSinceYear | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | Year | Month | Day | WeekOfYear | CompetitionOpen | Promo2Open | IsPromo2Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1016588 | 494 | 2 | 2013-01-01 | 3113 | 527 | 1 | 0 | a | 1 | b | a | 1260.0 | 6.0 | 2011.0 | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 19.0 | 0.000000 | 0 |
| 1016606 | 512 | 2 | 2013-01-01 | 2646 | 625 | 1 | 0 | a | 1 | b | b | 590.0 | NaN | NaN | 1 | 5.0 | 2013.0 | Mar,Jun,Sept,Dec | 2013 | 1 | 1 | 1 | 0.0 | 0.000000 | 0 |
| 1016624 | 530 | 2 | 2013-01-01 | 2907 | 532 | 1 | 0 | a | 1 | a | c | 18160.0 | NaN | NaN | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 0.0 | 0.000000 | 0 |
| 1016656 | 562 | 2 | 2013-01-01 | 8498 | 1675 | 1 | 0 | a | 1 | b | c | 1210.0 | NaN | NaN | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 0.0 | 0.000000 | 0 |
| 1016770 | 676 | 2 | 2013-01-01 | 3821 | 777 | 1 | 0 | a | 1 | b | b | 1410.0 | 9.0 | 2008.0 | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 52.0 | 0.000000 | 0 |
| 1016776 | 682 | 2 | 2013-01-01 | 3375 | 566 | 1 | 0 | a | 1 | b | a | 150.0 | 9.0 | 2006.0 | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 76.0 | 0.000000 | 0 |
| 1016827 | 733 | 2 | 2013-01-01 | 10765 | 2377 | 1 | 0 | a | 1 | b | b | 860.0 | 10.0 | 1999.0 | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 159.0 | 0.000000 | 0 |
| 1016863 | 769 | 2 | 2013-01-01 | 5035 | 1248 | 1 | 0 | a | 1 | b | b | 840.0 | NaN | NaN | 1 | 48.0 | 2012.0 | Jan,Apr,Jul,Oct | 2013 | 1 | 1 | 1 | 0.0 | 1.213115 | 1 |
| 1017042 | 948 | 2 | 2013-01-01 | 4491 | 1039 | 1 | 0 | a | 1 | b | b | 1430.0 | NaN | NaN | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 0.0 | 0.000000 | 0 |
| 1017190 | 1097 | 2 | 2013-01-01 | 5961 | 1405 | 1 | 0 | a | 1 | b | b | 720.0 | 3.0 | 2002.0 | 0 | NaN | NaN | NaN | 2013 | 1 | 1 | 1 | 130.0 | 0.000000 | 0 |